MacFormat UK 128

home *** CD-ROM | disk | FTP | other *** search

/ MacFormat UK 128 / MF_UK_128_1.iso / mac / CONTACTS OSX / CONTACTS DEMO Folder / DEMO_companies.fp5 (.txt) < prev next >

Wrap

FileMaker Pro Database | 2002-10-29 | 115.5 KB | 1,003 lines | [FMP5/UFSR]

DEMO_companies.fp5 FMP5UFSR Copyright 1984-1998 FileMaker, Inc. HBAM2016AUG95 Pro 5.0 block phoenix trading centre@ anecoopc/monforte covent garden market authoritycovent house@ fialliosapennproyect@ jodipadenchiquita brands international250 fifth street@ library@ HBAM3016AUG95@ active a12271 HP LaserJet 4ML MSUDO HP LaserJet 4ML ADDRESS 1 DUPE CHECK ADDRESS REF NO AREAS CO ADDRESS 1 CO ADDRESS 2 CO ADDRESS 3 CO ADDRESS 4 CO COUNTRY c CO COUNTY CO EMAIL CO POSTCODE COMPANY DUPE CHECK COMPANY NAME DATE FIRST CONTACTED DEMO MORE THAN FIVE INDICATOR DUPLICATE CHECK FAX NUMBER FREEFORM NOTES G_ADDRESS 1 FOR SEARCH G_ADDRESS 1 FOR SEARCH_DUPE G_CATEGORY HEADERS REF G_COMPANY FOR SEARCH G_COMPANY FOR SEARCH_DUPE G_DUPECHECK G_FIRST NAME FOR SEARCH G_INFO SCREEN }'G_NEW ADDRESS CREATED FROM CONTACT FILE G_OWNCATEGORIES_1 G_OWNCATEGORIES_2 G_OWNCATEGORIES_3 G_POSTCODE FOR SEARCH G_POSTCODE FOR SEARCH_DUPE G_SURNAME FOR SEARCH IMPORTANT COMMENTS MODIFIED DATE NEXT CONTACT DUE OWNCATEGORIES_1 OWNCATEGORIES_2 OWNCATEGORIES_3 POSTCODE DUPE CHECK RECORD CREATION DATE RECORD CREATION TIME Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Close Button make new activity go to related activity b_define categories Cancel 1. Amend details in the correct list 2. Then press COMPANIES to come back to the main screen. ;A"go to main screen from other files ------- dVeQdR Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 10/29/2002 8/9/99 v OwnCategories_1- type title here w OwnCategories_2- type title here x OwnCategories_3- type title here When doing a search for a set of fields that are empty - use the = sign and it will find you all blank fields Use an asterisk (*) to denote a wild card i.e. All names begining with BLU*. To look for (Find) a range of dates i.e. from May to September, use the format dd/mm/yyyy...dd/mm/yyyy (the three dots denote from...to . ) You can also use this to denote any from...to search such as from A to C, (A...C). Duplicate Checking - Go to list view and sort by First Name, Surname and CoB mpany. This will bring together all duplicate records. You can then check which ones need to be merged and which ones need to be deleted. (the three dots denote from...to . ) You can also use this to denote any from...to search such as from A to C, (A...C). Address Ref NoB A12272 Record creation dateB modified dateB CO Address 1B CO Address 2B CO Address 3B aA CO CountyB CO PostcodeB CO CountryB Where contact fromB eA TelephoneB Where contact fromB eA TelephoneB MobileB Direct LineB Direct LineB a11138 a11209@ a11287@ a11365@ a11442 a11521@ a11596 a11670 a11745@ quality agency@ siberian tiger foundation@ AqThis script is used when a contact is not found in the Contact file - and their company details are then checked.BSIf a company exists - it is found and then a new contact is set up at that company CoIf a company does not exist - a new company is set up and the contact is then setup related to that new companyD "yes" yesE# [A4b_go to layout details screen and create new contact = "yes" \A&First part - search from Contacts file ) > 1 CO EmailB date first contactedB who first contactedB OWNcategories_1B OWNcategories_2B OWNcategories_3B Company NameB Important CommentsB fax numberB G_OWNCategories_1B G_OWNCategories_2B fax numberB G_OWNCategories_1B G_OWNCategories_2B Phone CO Email Company Postcode MARIA activity.fp3 NAMEA DEMO_activity RPTHA DEMO_activity MARIA workflow.fp3 NAMEA CM_workflow.fp5 RPTHA CM_workflow.fp5 NAME MARIA menu.fp3 NAMEA DEMO_MENU RPTHA DEMO_MENU MARIA activity.fp3 NAMEA DEMO_activity RPTHA DEMO_activity MARIA category.fp3 NAMEA DEMO_category RPTHA DEMO_category MARIA workflow.fp3 NAMEA CM_workflow.fp5 RPTHA CM_workflow.fp5 MARIA market.fp3 NAMEA DEMO_market RPTHA DEMO_market NAMEA DEMO_contacts RPTHA DEMO_contacts Categories ScreenB Contacts Categories Notes Companies Important Comments Define Categories Record Delete Record Record List View Print Record Close Database Status Ref Number Address County Country NotesB )A List viewB north yorkshire@ touche@ dublin mayo@ county@ county dublin@ dublin@ ireland westmeath@ 0574@ 2832411@ 2989826@ 8900@ 3422@ 0311@ 0691@ 0141@ b_7162 labels HP LaserJet 4ML MSUDO HP LaserJet 4ML b_7165 labels HP LaserJet 4ML MSUDO HP LaserJet 4ML C:\Program Files\Claris Corp\Claris\ UKENGLSH.MPR C:\Program Files\Claris Corp\Claris\ USER.UPR ) = "2" W*If record was created from CONTACTS searchX) = "yes" Cancel Please enter the rest of the details on this screen.[+ ) > 1 Cancel Please choose a Company from the list below or select CREATE NEW ADDRESS. SA%CreatE New Record from Results screen = "yes" dupe check for addresses "yes" go to blank b_print report first half Delete record print current record "yes" go to blank b_print report first half 08586 701212@ 701212@ 701212@ 701212@ 1212@ 701212@ 01212@ 884121@ 833333@ 8441@ 8441@ 8441@ 8441@ 8441@ 8441@ 8441@ 8441@ 2832411@ 2989826@ 1600@ 8900@ 4377@ 3422@ 2755@ 6285222@ 0311@ 0691@ 0141@ ) > 200000000 Cancel G_OWNCAT GORIES_1 This is a demo copy of Workflow - you can not have more than 5 records. To upgrade contact Cruse Control on 01923 842 295. workflow@crusecontrol.comC "yes" yesD# Company NameE CO PostcodeF Telephone Create New Address_ Search Results Foundh Form Viewi Menuj Address line 1 sdsd@ sdsd@ mited@ limited@ atermark@ watermark@ atermark@ mark@ ultimate@ ultimate@ jacobson@ nect@ terconnect@ connect@ nterconnect@ nnect@ rconnect@ connect@ interconnect@ onnect@ nect@ connect@ erconnect@ onnect@ connect@ terconnect@ onnect@ erconnect@ interconnect@ erconnect@ rconnect@ investments@ land@ land@ ireland@ eland@ intel ireland@ ireland@ uthority@ irish pride@ wood@ kilkenny@ kpmg@ wright group life@ logic rite@ mallinckrodt medical imaging@ matsushika@ meats@ Company NameF TelephoneR SortU RecordV Form ViewW Print ReportX Print Menu_ Postcodea Address line 1h Close Button opening script "go to main screen from other files &go to activity screen from other files go to menu ------- make new activity go to related activity ------- b_define categories ------- b_print report first half b_print report second half b_list view ------- JOB SCREEN ------ b_new job b_print menu b_7162 labels b_7165 labels b_DL Envelopes ------- New Searches ------ First part - search ,&First part - search from Contacts file continue search 0%CreatE New Record from Results screen go to related workflow job b_OLD define categories Copy copy address Find records b_go to related contact sub_check address file >4b_go to layout details screen and create new contact dupe check for addresses go to blank Delete record print current record go to web site ------- DEMO Script ------ demo closing script imported checking script d'alsace@ enriquefernandezmitr@ fibre@ first@ franco@ galleon@ gjatat farms trading limited@ gront@ hansvan@ seguradorua teatro eduardo costa@ john's@ jongmarconistraat@ josef@ justinfarrington-smi@ lagnasco@ justinfarrington-smi@ lagnasco@ justinfarrington-smi@ lagnasco@ lagnasco@ lagnasco@ maringa@ lagnasco@ maringa@ lagnasco@ maringa@ lagnasco@ maringa@ lagnasco@ altesse l'aga khan@ liothequesecretar altesse l'aga khan@ fvfvf@ fvfvf@ road@ road@ street@ street@ street@ street@ street@ upper@ upper@ upper@ upper@ unit@ unit@ mpus@ mpus@ campus@ siness camden@ amden@ camden@ camden@ camden@ clara@ collinstown cross@ corcanree@ deloitte touche house@ dock@ dundrum@ edgeworthstown@ estate european@ ferryport@ finiskilin@ finnabair industrial park@ gate@ greenhills@ head@ holyhill@ huguenot@ business park@ ifsc@ industrial industrial estate@ kilbarry industrial estate@ kildare town@ knocknumber@ level@ MARI@ ZONE@ woodthames@ worldfresh@ wyberton@ yichupyotrading@ yumischleifer1177@ yuvam@ zagora@ zaragoza@ ziyaogan@ zona@ zone@ ------B New Record SearchB LD56 78L LD5678L A11819 contacts Screen Categories Screen DL Envelopes Avery 7165 Labels DL EnvelopeB ABHB>> ABFO>> ABFP>> ABGA>> ACIABM>> ABGB>> ABGC>> ABGD>> Avery 7165B ABHB>> ABFO>> ABFP>> ABGA>> ACIABM>> ABGB>> ABGC>> ABGD>> Search ScreenB 01932 738880@ 738880@ 8880@ 5878@ 5878@ 5878@ 8858@ 8858@ 8858@ 5878@ 5878@ 5878@ 5878@ 0375@ 0375@ 0375@ serv@ 7587@ serv@ 7587@ serv@ 8691@ serv@ OA_Choose a format for printing names and addresses for the << ACIAAA>> records currently selected Cancel Print Menu Avery 7162 Labels RECORD MOD DATE RECORD MOD TIME STATUS @ TELEPHONE TITLE FOR REPORT TODAYS DATE 8 TOTAL NUMBER OF RECORDS SELECTED WHERE CONTACT FROM WHO FIRST CONTACTED YES DUPE Todays DateB Freeform NotesB StatusB Active ------- DEMO Script ------ checking script ) < 1 Avery 7162B ABHB>> ABFO>> ABFP>> ABGA>> ACIABM>> ABGB>> << ABGC>> ABGD>> g_address 1 for searchB A'g_New address created from contact fileB areasB g_dupecheckB yes dupeB CO Address 4B CO Address 4B CO Address 4B CO Address 4B CO Address 4B Address 4B go to web site demo closing script imported ) > 5 Cancel More than 5 address records have been found. This is a demo version of CONTACTS. To order a full copy of CONTACTS! contact CRUSE CONTROL on 01923 842 295, or email: contacts@crusecontrol.com. ------ DEMO Script ------ fvfvf@ fvfvf@ fvfvf@ 3cornhill@ 3cornhill@ 3cornhill@ 80stanhopegate@ ited2 unit12@ rialesta@ trinitystreet@ vhihouse@ vhihouse@ teddrughouse@ unidarehouse@ unidarehouse@ unidarehouse@ industriale@ ustriale@ whitemillindustriale@ temillindustriale@ illindustriale@ illindustriale@ llindustriale@ iale@ RECORD MOD DATE Helvetica Arial MS Sans Serif MS Dialog Light Wingdings Book Antiqua Arial Black Geneva Times MARIA costs.fp3 NAMEA CM_costs.fp5 RPTHA CM_costs.fp5 MARIA costs.fp3 NAMEA CM_costs.fp5 RPTHA CM_costs.fp5 Pro 3.0F! Pro 5.0 - 6.0 UKENGLSH.MPR E If number of records equals noneF+ ) = 0 I*If record was created from CONTACTS searchJ) = "yes" Cancel Please enter the rest of the details on this screen.M If number of records equals ONEN+ ) = 1 Make New If this is not the correct record - select Make New, or select OK to continueP' ) = "1" Q*If record was created from CONTACTS searchR) = "yes" HP LaserJet 4ML MSUDO HP LaserJet 4ML MSUDO HP LaserJet 4ML (LIST LISTA Active Inactive VDEFA( (LIST LISTA VDEFA( (LIST LISTA category 1 category 2 VDEFA( (LIST LISTAW1-5 10-25 25-50 50-100 100-500 500-1,000 1,000-5,000 5,000-10,000 more than 10,000 VDEFA( (LIST LISTArLess than 41k - 101K - 200k - 500k - 1m - 5m - 10m - 20m More than VDEFA( (LIST VDEFA( Report Title R Form View Information ScreenB b_go to related contact ------- New Searches ------ First part - search ) > 200000000 Cancel G_OWNCAT GORIES_1 This is a demo copy of Workflow - you can not have more than 5 records. To upgrade contact Cruse Control on 01923 842 295. workflow@crusecontrol.comC continue search Cancel Please enter the rest of the details on this screen. TA&go to activity screen from other files go to related workflow job b_OLD define categories Copy Cancel 1. Select the categorty list you wish to amend on the top left of the following screen 2. Amend the details in the middle of the screen 3. Press SAVE then press DONE. copy address demo closing script Find records ) > 1 sub_check address file More than 5 records have been found. This is a demo version. To order a full copy of WORKFLOWplus! contact CRUSE CONTROL on 01923 842 295, or email: workflow@crusecontrol.com. Find records ) > 1 sub_check address file ------- ------- b_list view CA b_new job ------- JOB SCREEN ------ go to menu opening script b_print menu ------- ------- b_print report first half HP LaserJet 4ML MSUDO HP LaserJet 4ML HP LaserJet 4ML MSUDO HP LaserJet 4ML Address County Country Phone CO Email Company Categories Postcode (LIST LISTA VDEFA( (LIST LISTAkAustralia Brazil Canada Denmark France Germany Holland Italy Japan Luxembourg Portugal Spain Turkey VDEFA( Active StatusP SalutationR OWNCategories_1S OWNCategories_2T OWNCategories_3U address checkingV yesW countries FMRLA FMRLA FMRLA SORTA FMRLA Dupe CheckG CategoryH ContactsK Webaddr Contacts Categories Notes Notes Companies Status Ref Number Address County Postcode Country Phone CO Email Company Record Delete Record Record n List View Print Record Close Database Useful Tips Information Screen Back to database ------B -----B Print MenuB Notes @%A List view Title for report Information Screen ------ ----- Print Menu DL Envelope Avery 7165 Avery 7162 ------ New Record Search Search Screen blank for closing contacts ScreenB blank for closingB Active A12271 29/10/2002 29/10/2002 29/10/2002 1:40:39 pm 1:40:39 pm G_OWNCategories_3B next contact dueB duplicate checkB Title for reportB g_info screenB A Total number of records selectedB g_category headers refB g_first name for searchB g_surname for searchB g_postcode for searchB g_company for searchB Suggestions Record Delete Record Record List View Print Record Close Database Contacts Notes Companies First name Surname Direct Line Mobile Status Ref Number O"Please enter the following details Cancel Search Screen Postcode Company Continue ZONEA NAMEA DEMO_webaddr RPTHA DEMO_webaddr RolyA NAMEA DEMO_webaddr RPTHA@::::Applications (Mac OS 9):FileMaker Developer 5.5:DEMO_webaddr Roly NAMEA DEMO_MENU RPTHA DEMO_MENU RolyA RolyA 7Macintosh HD:Work:Purcon_Workflow 25_01_01:P_market.fp5 Paul Cruse s Computer Macintosh HD Paul Cruse Paul Cruse demo more than five indicatorB Record mod dateB Record mod timeB Record creation timeB g_company for search_dupeB g_postcode for search_dupeB address 1 dupe checkB company dupe checkB postcode dupe checkB g_address 1 for search_dupeB g_address 1 for search_dupe g_address 1 for search_dupe g_address 1 for search_dupedress 1 for search_dupe g_address 1 for search_dupedress 1 for search_dupe Title for reportB O>Please enter the title for your report here and press continue Continueinue b_DL Envelopes HP LaserJet 4ML MSUDO HP LaserJet 4ML b_print report second half ttvfgala